SaRefundCalculationRoutingTemplate

Logical Entity Name | SaRefundCalculationRoutingTemplate
Default Table Name | SaRefundCalculationRoutingTemplate
Physical Only | NO
Owner | dbo
Definition |
Note |

SaRefundCalculationRoutingTemplate Columns

ColumnName | Domain | Datatype | NULL | Definition
SaRefundCalculationRoutingTemplateID |  | int | NO |
AssignedStaffGroupID |  | int | YES |
AssignedStaffID |  | int | YES |
SyServiceExceptionRoutingTypeID |  | int | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
SaRefundCalculationConfigurationID |  | int | NO |
CalculationType |  | char(1) | YES |

SaRefundCalculationRoutingTemplate Primary and Unique Keys

Key Name | Key Type | Keys
Uk_SaRefundCalculationRoutingTemplate_AssignedStaffGroupIDAssignedStaffIDCalcTypeConfigId | Index | AssignedStaffGroupID, AssignedStaffID, CalculationType, SaRefundCalculationConfigurationID
Pk_SaRefundCalculationRoutingTemplate_SaRefundCalculationRoutingTemplateID | PrimaryKey | SaRefundCalculationRoutingTemplateID

SaRefundCalculationRoutingTemplate Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SaRefundCalculationConfiguration | Non-Identifying | One To Zero or More | FK_SaRefundCalculationConfigurationID_SaRefundCalculationConfigurationConfigurationID |  |  | SaRefundCalculationConfigurationID | NO | YES
SyStaffGroup | Non-Identifying | Zero or One to Zero or More | FK_SaRefundCalculationRoutingTemplateAssignedStaffGroupID_SyStaffGroupSyStaffGroupID |  |  | AssignedStaffGroupID | NO | YES
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_SaRefundCalculationRoutingTemplateAssignedStaffID_SyStaffSyStaffID |  |  | AssignedStaffID | NO | YES
SyServiceExceptionRoutingType | Non-Identifying | One To Zero or More | FK_SaRefundCalculationRoutingTemplateRoutingTypeID_SyServiceExceptionRoutingTypeTypeID |  |  | SyServiceExceptionRoutingTypeID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_SaRefundCalculationRoutingTemplateUserID_SyStaffSyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

SaRefundCalculationRoutingTemplate Check Constraints

Check Constraint Name | CheckConstraint

SaRefundCalculationRoutingTemplate Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SaRefundCalculationRoutingTemplate Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SaRefundCalculationRoutingTemplate | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaRefundCalculationRoutingTemplate | NO |  |  |

SaRefundCalculationRoutingTemplate Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

SaRefundCalculationRoutingTemplate Data Movement Rules

Name | Type | Rule Text/Value